{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "f3c9aa1d",
   "metadata": {},
   "source": [
    "数科三班 宋池 320200945881"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "96e55bed",
   "metadata": {},
   "source": [
    "1.筛选confidence >= 0.9 的记录。"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "id": "33779d74",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "        gaze_timestamp  world_index  confidence  norm_pos_x  norm_pos_y  \\\n",
      "21        88150.825638            2    0.915197    0.493612    0.398950   \n",
      "22        88150.827729            2    0.915197    0.493561    0.399305   \n",
      "23        88150.829663            2    0.915197    0.493570    0.399542   \n",
      "39        88150.866015            3    0.922197    0.492592    0.398705   \n",
      "40        88150.869620            3    0.922197    0.492635    0.398814   \n",
      "...                ...          ...         ...         ...         ...   \n",
      "125259    88443.695600         8788    0.995336    0.407831    0.413470   \n",
      "125260    88443.697570         8788    0.948733    0.407552    0.414731   \n",
      "125261    88443.701580         8788    0.945284    0.407467    0.414705   \n",
      "125262    88443.703608         8788    0.945284    0.407160    0.415340   \n",
      "125263    88443.705574         8788    0.945284    0.407637    0.413674   \n",
      "\n",
      "                                 base_data  gaze_point_3d_x  gaze_point_3d_y  \\\n",
      "21           88150.827729-0 88150.823548-1         2.412810       -21.468145   \n",
      "22           88150.827729-0 88150.827729-1         2.429837       -21.374413   \n",
      "23      88150.827729-0 88150.83159799999-1         2.427118       -21.328193   \n",
      "39      88150.867514-0 88150.86451599999-1         2.827911       -21.750938   \n",
      "40           88150.867514-0 88150.871726-1         2.813774       -21.744854   \n",
      "...                                    ...              ...              ...   \n",
      "125259        88443.69561-0 88443.695591-1       327.648915      -173.027524   \n",
      "125260   88443.69561-0 88443.69953099999-1       311.054477      -161.381388   \n",
      "125261  88443.703629-0 88443.69953099999-1       313.566509      -162.585330   \n",
      "125262       88443.703629-0 88443.703587-1       297.019831      -152.352987   \n",
      "125263  88443.703629-0 88443.70751899999-1       323.629974      -170.142461   \n",
      "\n",
      "        gaze_point_3d_z  eye_center0_3d_x  ...  eye_center0_3d_z  \\\n",
      "21          -295.071057         20.000000  ...        -20.000000   \n",
      "22          -294.819200         20.000000  ...        -20.000000   \n",
      "23          -294.874516         20.000000  ...        -20.000000   \n",
      "39          -298.233245         20.000000  ...        -20.000000   \n",
      "40          -298.471253         20.000000  ...        -20.000000   \n",
      "...                 ...               ...  ...               ...   \n",
      "125259     -2777.243340         19.888755  ...        -20.707271   \n",
      "125260     -2628.637408         19.888755  ...        -20.707271   \n",
      "125261     -2647.420719         19.888755  ...        -20.707271   \n",
      "125262     -2499.428189         19.888755  ...        -20.707271   \n",
      "125263     -2737.404466         19.888755  ...        -20.707271   \n",
      "\n",
      "        gaze_normal0_x  gaze_normal0_y  gaze_normal0_z  eye_center1_3d_x  \\\n",
      "21            0.062883        0.025100        0.997705        -39.934928   \n",
      "22            0.062883        0.025100        0.997705        -39.934928   \n",
      "23            0.062883        0.025100        0.997705        -39.934928   \n",
      "39            0.060717        0.025220        0.997836        -39.934928   \n",
      "40            0.060717        0.025220        0.997836        -39.934928   \n",
      "...                ...             ...             ...               ...   \n",
      "125259       -0.110854        0.041843        0.992955        -37.372594   \n",
      "125260       -0.110854        0.041843        0.992955        -37.372594   \n",
      "125261       -0.111009        0.041794        0.992940        -37.372594   \n",
      "125262       -0.111009        0.041794        0.992940        -37.372594   \n",
      "125263       -0.111009        0.041794        0.992940        -37.372594   \n",
      "\n",
      "        eye_center1_3d_y  eye_center1_3d_z  gaze_normal1_x  gaze_normal1_y  \\\n",
      "21             14.997919        -20.075283       -0.150041        0.234536   \n",
      "22             14.997919        -20.075283       -0.150243        0.234115   \n",
      "23             14.997919        -20.075283       -0.150210        0.233747   \n",
      "39             14.997919        -20.075283       -0.149814        0.233510   \n",
      "40             14.997919        -20.075283       -0.149645        0.233258   \n",
      "...                  ...               ...             ...             ...   \n",
      "125259         14.763454        -23.294339       -0.130868        0.093021   \n",
      "125260         14.763454        -23.294339       -0.132037        0.091860   \n",
      "125261         14.763454        -23.294339       -0.132037        0.091860   \n",
      "125262         14.763454        -23.294339       -0.133311        0.091656   \n",
      "125263         14.763454        -23.294339       -0.131320        0.092941   \n",
      "\n",
      "        gaze_normal1_z  \n",
      "21            0.960458  \n",
      "22            0.960530  \n",
      "23            0.960624  \n",
      "39            0.960744  \n",
      "40            0.960831  \n",
      "...                ...  \n",
      "125259        0.987026  \n",
      "125260        0.986979  \n",
      "125261        0.986979  \n",
      "125262        0.986827  \n",
      "125263        0.986974  \n",
      "\n",
      "[87442 rows x 21 columns]\n"
     ]
    }
   ],
   "source": [
    "import pandas as pd\n",
    "sheet = pd.read_csv(r'C:\\Users\\86152\\Desktop\\gaze.csv')\n",
    "sheet1 = sheet.loc[sheet['confidence'] >= 0.9]\n",
    "#sheet1即第一题筛选后数据"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "dbb6d870",
   "metadata": {},
   "source": [
    "2.正态分布筛选"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "id": "32dd10a9",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "        gaze_timestamp  world_index  confidence  norm_pos_x  norm_pos_y  \\\n",
      "21        88150.825638            2    0.915197    0.493612    0.398950   \n",
      "22        88150.827729            2    0.915197    0.493561    0.399305   \n",
      "23        88150.829663            2    0.915197    0.493570    0.399542   \n",
      "39        88150.866015            3    0.922197    0.492592    0.398705   \n",
      "40        88150.869620            3    0.922197    0.492635    0.398814   \n",
      "...                ...          ...         ...         ...         ...   \n",
      "125259    88443.695600         8788    0.995336    0.407831    0.413470   \n",
      "125260    88443.697570         8788    0.948733    0.407552    0.414731   \n",
      "125261    88443.701580         8788    0.945284    0.407467    0.414705   \n",
      "125262    88443.703608         8788    0.945284    0.407160    0.415340   \n",
      "125263    88443.705574         8788    0.945284    0.407637    0.413674   \n",
      "\n",
      "                                 base_data  gaze_point_3d_x  gaze_point_3d_y  \\\n",
      "21           88150.827729-0 88150.823548-1         2.412810       -21.468145   \n",
      "22           88150.827729-0 88150.827729-1         2.429837       -21.374413   \n",
      "23      88150.827729-0 88150.83159799999-1         2.427118       -21.328193   \n",
      "39      88150.867514-0 88150.86451599999-1         2.827911       -21.750938   \n",
      "40           88150.867514-0 88150.871726-1         2.813774       -21.744854   \n",
      "...                                    ...              ...              ...   \n",
      "125259        88443.69561-0 88443.695591-1       327.648915      -173.027524   \n",
      "125260   88443.69561-0 88443.69953099999-1       311.054477      -161.381388   \n",
      "125261  88443.703629-0 88443.69953099999-1       313.566509      -162.585330   \n",
      "125262       88443.703629-0 88443.703587-1       297.019831      -152.352987   \n",
      "125263  88443.703629-0 88443.70751899999-1       323.629974      -170.142461   \n",
      "\n",
      "        gaze_point_3d_z  eye_center0_3d_x  ...  eye_center0_3d_z  \\\n",
      "21          -295.071057         20.000000  ...        -20.000000   \n",
      "22          -294.819200         20.000000  ...        -20.000000   \n",
      "23          -294.874516         20.000000  ...        -20.000000   \n",
      "39          -298.233245         20.000000  ...        -20.000000   \n",
      "40          -298.471253         20.000000  ...        -20.000000   \n",
      "...                 ...               ...  ...               ...   \n",
      "125259     -2777.243340         19.888755  ...        -20.707271   \n",
      "125260     -2628.637408         19.888755  ...        -20.707271   \n",
      "125261     -2647.420719         19.888755  ...        -20.707271   \n",
      "125262     -2499.428189         19.888755  ...        -20.707271   \n",
      "125263     -2737.404466         19.888755  ...        -20.707271   \n",
      "\n",
      "        gaze_normal0_x  gaze_normal0_y  gaze_normal0_z  eye_center1_3d_x  \\\n",
      "21            0.062883        0.025100        0.997705        -39.934928   \n",
      "22            0.062883        0.025100        0.997705        -39.934928   \n",
      "23            0.062883        0.025100        0.997705        -39.934928   \n",
      "39            0.060717        0.025220        0.997836        -39.934928   \n",
      "40            0.060717        0.025220        0.997836        -39.934928   \n",
      "...                ...             ...             ...               ...   \n",
      "125259       -0.110854        0.041843        0.992955        -37.372594   \n",
      "125260       -0.110854        0.041843        0.992955        -37.372594   \n",
      "125261       -0.111009        0.041794        0.992940        -37.372594   \n",
      "125262       -0.111009        0.041794        0.992940        -37.372594   \n",
      "125263       -0.111009        0.041794        0.992940        -37.372594   \n",
      "\n",
      "        eye_center1_3d_y  eye_center1_3d_z  gaze_normal1_x  gaze_normal1_y  \\\n",
      "21             14.997919        -20.075283       -0.150041        0.234536   \n",
      "22             14.997919        -20.075283       -0.150243        0.234115   \n",
      "23             14.997919        -20.075283       -0.150210        0.233747   \n",
      "39             14.997919        -20.075283       -0.149814        0.233510   \n",
      "40             14.997919        -20.075283       -0.149645        0.233258   \n",
      "...                  ...               ...             ...             ...   \n",
      "125259         14.763454        -23.294339       -0.130868        0.093021   \n",
      "125260         14.763454        -23.294339       -0.132037        0.091860   \n",
      "125261         14.763454        -23.294339       -0.132037        0.091860   \n",
      "125262         14.763454        -23.294339       -0.133311        0.091656   \n",
      "125263         14.763454        -23.294339       -0.131320        0.092941   \n",
      "\n",
      "        gaze_normal1_z  \n",
      "21            0.960458  \n",
      "22            0.960530  \n",
      "23            0.960624  \n",
      "39            0.960744  \n",
      "40            0.960831  \n",
      "...                ...  \n",
      "125259        0.987026  \n",
      "125260        0.986979  \n",
      "125261        0.986979  \n",
      "125262        0.986827  \n",
      "125263        0.986974  \n",
      "\n",
      "[86185 rows x 21 columns]\n"
     ]
    }
   ],
   "source": [
    "x_m = sheet1['norm_pos_x'].mean()\n",
    "x_s = sheet1['norm_pos_x'].std()\n",
    "x_max = x_m + 3*x_s\n",
    "x_min = x_m - 3*x_s\n",
    "y_m = sheet1['norm_pos_y'].mean()\n",
    "y_s = sheet1['norm_pos_y'].std()\n",
    "y_max = y_m + 3*y_s\n",
    "y_min = y_m - 3*y_s\n",
    "sheet2 = sheet1.loc[(sheet1['norm_pos_x'] <= x_max)&(sheet1['norm_pos_x'] >= x_min)&(sheet1['norm_pos_y']<= y_max)&(sheet1['norm_pos_y']>= y_min)]\n",
    "print(sheet2)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "9afa3d87",
   "metadata": {},
   "source": [
    "3.时间戳转化"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "id": "088b27ac",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                      gaze_timestamp  world_index  confidence  norm_pos_x  \\\n",
      "21     1970-01-02 00:29:10.825638500            2    0.915197    0.493612   \n",
      "22     1970-01-02 00:29:10.827729000            2    0.915197    0.493561   \n",
      "23     1970-01-02 00:29:10.829663499            2    0.915197    0.493570   \n",
      "39     1970-01-02 00:29:10.866015000            3    0.922197    0.492592   \n",
      "40     1970-01-02 00:29:10.869620000            3    0.922197    0.492635   \n",
      "...                              ...          ...         ...         ...   \n",
      "125259 1970-01-02 00:34:03.695600500         8788    0.995336    0.407831   \n",
      "125260 1970-01-02 00:34:03.697570500         8788    0.948733    0.407552   \n",
      "125261 1970-01-02 00:34:03.701580000         8788    0.945284    0.407467   \n",
      "125262 1970-01-02 00:34:03.703608000         8788    0.945284    0.407160   \n",
      "125263 1970-01-02 00:34:03.705574000         8788    0.945284    0.407637   \n",
      "\n",
      "        norm_pos_y                           base_data  gaze_point_3d_x  \\\n",
      "21        0.398950       88150.827729-0 88150.823548-1         2.412810   \n",
      "22        0.399305       88150.827729-0 88150.827729-1         2.429837   \n",
      "23        0.399542  88150.827729-0 88150.83159799999-1         2.427118   \n",
      "39        0.398705  88150.867514-0 88150.86451599999-1         2.827911   \n",
      "40        0.398814       88150.867514-0 88150.871726-1         2.813774   \n",
      "...            ...                                 ...              ...   \n",
      "125259    0.413470        88443.69561-0 88443.695591-1       327.648915   \n",
      "125260    0.414731   88443.69561-0 88443.69953099999-1       311.054477   \n",
      "125261    0.414705  88443.703629-0 88443.69953099999-1       313.566509   \n",
      "125262    0.415340       88443.703629-0 88443.703587-1       297.019831   \n",
      "125263    0.413674  88443.703629-0 88443.70751899999-1       323.629974   \n",
      "\n",
      "        gaze_point_3d_y  gaze_point_3d_z  eye_center0_3d_x  ...  \\\n",
      "21           -21.468145      -295.071057         20.000000  ...   \n",
      "22           -21.374413      -294.819200         20.000000  ...   \n",
      "23           -21.328193      -294.874516         20.000000  ...   \n",
      "39           -21.750938      -298.233245         20.000000  ...   \n",
      "40           -21.744854      -298.471253         20.000000  ...   \n",
      "...                 ...              ...               ...  ...   \n",
      "125259      -173.027524     -2777.243340         19.888755  ...   \n",
      "125260      -161.381388     -2628.637408         19.888755  ...   \n",
      "125261      -162.585330     -2647.420719         19.888755  ...   \n",
      "125262      -152.352987     -2499.428189         19.888755  ...   \n",
      "125263      -170.142461     -2737.404466         19.888755  ...   \n",
      "\n",
      "        eye_center0_3d_z  gaze_normal0_x  gaze_normal0_y  gaze_normal0_z  \\\n",
      "21            -20.000000        0.062883        0.025100        0.997705   \n",
      "22            -20.000000        0.062883        0.025100        0.997705   \n",
      "23            -20.000000        0.062883        0.025100        0.997705   \n",
      "39            -20.000000        0.060717        0.025220        0.997836   \n",
      "40            -20.000000        0.060717        0.025220        0.997836   \n",
      "...                  ...             ...             ...             ...   \n",
      "125259        -20.707271       -0.110854        0.041843        0.992955   \n",
      "125260        -20.707271       -0.110854        0.041843        0.992955   \n",
      "125261        -20.707271       -0.111009        0.041794        0.992940   \n",
      "125262        -20.707271       -0.111009        0.041794        0.992940   \n",
      "125263        -20.707271       -0.111009        0.041794        0.992940   \n",
      "\n",
      "        eye_center1_3d_x  eye_center1_3d_y  eye_center1_3d_z  gaze_normal1_x  \\\n",
      "21            -39.934928         14.997919        -20.075283       -0.150041   \n",
      "22            -39.934928         14.997919        -20.075283       -0.150243   \n",
      "23            -39.934928         14.997919        -20.075283       -0.150210   \n",
      "39            -39.934928         14.997919        -20.075283       -0.149814   \n",
      "40            -39.934928         14.997919        -20.075283       -0.149645   \n",
      "...                  ...               ...               ...             ...   \n",
      "125259        -37.372594         14.763454        -23.294339       -0.130868   \n",
      "125260        -37.372594         14.763454        -23.294339       -0.132037   \n",
      "125261        -37.372594         14.763454        -23.294339       -0.132037   \n",
      "125262        -37.372594         14.763454        -23.294339       -0.133311   \n",
      "125263        -37.372594         14.763454        -23.294339       -0.131320   \n",
      "\n",
      "        gaze_normal1_y  gaze_normal1_z  \n",
      "21            0.234536        0.960458  \n",
      "22            0.234115        0.960530  \n",
      "23            0.233747        0.960624  \n",
      "39            0.233510        0.960744  \n",
      "40            0.233258        0.960831  \n",
      "...                ...             ...  \n",
      "125259        0.093021        0.987026  \n",
      "125260        0.091860        0.986979  \n",
      "125261        0.091860        0.986979  \n",
      "125262        0.091656        0.986827  \n",
      "125263        0.092941        0.986974  \n",
      "\n",
      "[87442 rows x 21 columns]\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "<ipython-input-53-6fc6dc614de9>:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  sheet1['gaze_timestamp']=pd.to_datetime(sheet1['gaze_timestamp'],unit='s')\n"
     ]
    }
   ],
   "source": [
    "sheet1['gaze_timestamp']=pd.to_datetime(sheet1['gaze_timestamp'],unit='s')\n",
    "print(sheet1)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "fe0f756b",
   "metadata": {},
   "source": [
    "4.求该数据的采样率"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a4fe45bb",
   "metadata": {},
   "source": [
    "采样率：也称为采样速度或者采样频率，定义了每秒从连续信号中提取并组成离散信号的采样个数，它用赫兹（Hz）来表示。采样频率的倒数是采样周期或者叫作采样时间，它是采样之间的时间间隔。通俗的讲采样频率是指计算机每秒钟采集多少个声音样本，是描述声音文件的音质、音调，衡量声卡、声音文件的质量标准\n",
    "————————————————\n",
    "版权声明：本文为CSDN博主「yiruohan」的原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接及本声明。\n",
    "原文链接：https://blog.csdn.net/yiruohan/article/details/84522410"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "6a274587",
   "metadata": {},
   "source": [
    "4.解：由第三题输出的数据看，第125263条记录的采样时间是 1970-01-02 00:34:03.705574000，第21条数据的采样时间是     1970-01-02 00:29:10.825638500，总时间是4分53秒（精确到整秒）即293秒，采集的记录数是87442"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "id": "b799f883",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "数据的采用采样率为298.559203 HZ\n"
     ]
    }
   ],
   "source": [
    "n = 87442/(293+(0.705574000-0.825638500))\n",
    "print(\"数据的采用采样率为%f HZ\"%n)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "04d81682",
   "metadata": {},
   "source": [
    "5.按照100HZ的采样率重新取样20行数据"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "b436d3a4",
   "metadata": {},
   "source": [
    "解：采样率为100HZ几乎是298.6HZ的三分之一，也就是原数据集每采样3次，新数据集采样一次"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "id": "00a2a95e",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "    88150.779709  0  0.888789360206567  0.5431396650463463  \\\n",
      "0   88150.779759  0           0.550258            0.337923   \n",
      "1   88150.787485  1           0.502595            0.340109   \n",
      "2   88150.787580  1           0.625134            0.484139   \n",
      "3   88150.789480  1           0.625134            0.489687   \n",
      "4   88150.793583  1           0.625134            0.495993   \n",
      "5   88150.795683  1           0.706355            0.493975   \n",
      "6   88150.798406  1           0.708476            0.494116   \n",
      "7   88150.801140  1           0.708476            0.495145   \n",
      "8   88150.802973  1           0.839662            0.495216   \n",
      "9   88150.804631  1           0.791032            0.494728   \n",
      "10  88150.807269  1           0.856341            0.494777   \n",
      "11  88150.809749  1           0.856341            0.494888   \n",
      "12  88150.812873  2           0.856341            0.494809   \n",
      "13  88150.814136  2           0.716398            0.494057   \n",
      "14  88150.815998  2           0.836166            0.493629   \n",
      "15  88150.818051  2           0.836166            0.493772   \n",
      "16  88150.821819  2           0.861113            0.493453   \n",
      "17  88150.823541  2           0.861113            0.493829   \n",
      "18  88150.825638  2           0.915197            0.493612   \n",
      "19  88150.827729  2           0.915197            0.493561   \n",
      "\n",
      "    0.4106679784529125                           88150.779709-0  \\\n",
      "0             0.173301                           88150.779759-1   \n",
      "1             0.142989                           88150.787485-1   \n",
      "2             0.385491  88150.78368299999-0 88150.79147699999-1   \n",
      "3             0.392849       88150.787484-0 88150.79147699999-1   \n",
      "4             0.399021        88150.79569-0 88150.79147699999-1   \n",
      "5             0.408429             88150.79569-0 88150.795675-1   \n",
      "6             0.407109             88150.79569-0 88150.801123-1   \n",
      "7             0.408338            88150.801157-0 88150.801123-1   \n",
      "8             0.403442             88150.801157-0 88150.80479-1   \n",
      "9             0.405146             88150.804471-0 88150.80479-1   \n",
      "10            0.404969             88150.809749-0 88150.80479-1   \n",
      "11            0.402216            88150.809749-0 88150.809748-1   \n",
      "12            0.402125            88150.809749-0 88150.815997-1   \n",
      "13            0.401233       88150.81227499999-0 88150.815997-1   \n",
      "14            0.400583       88150.81599799999-0 88150.815997-1   \n",
      "15            0.400270       88150.81599799999-0 88150.820104-1   \n",
      "16            0.399839            88150.823534-0 88150.820104-1   \n",
      "17            0.399040            88150.823534-0 88150.823548-1   \n",
      "18            0.398950            88150.827729-0 88150.823548-1   \n",
      "19            0.399305            88150.827729-0 88150.827729-1   \n",
      "\n",
      "    38.9420506661925  45.3598633490285  705.2321117996576       20.0  ...  \\\n",
      "0        -141.879169        160.867779         683.893108 -39.934928  ...   \n",
      "1        -139.404860        175.088321         681.151453 -39.934928  ...   \n",
      "2           6.784204        -27.550520        -334.161525  20.000000  ...   \n",
      "3           4.180437        -24.431546        -316.680240  20.000000  ...   \n",
      "4           1.533100        -21.730862        -298.890441  20.000000  ...   \n",
      "5           2.226758        -19.036160        -288.727225  20.000000  ...   \n",
      "6           2.179629        -19.354530        -289.386597  20.000000  ...   \n",
      "7           1.782444        -18.930993        -286.849309  20.000000  ...   \n",
      "8           1.757366        -19.951730        -286.984799  20.000000  ...   \n",
      "9           1.944664        -19.682136        -288.194181  20.000000  ...   \n",
      "10          1.925755        -19.710658        -288.072115  20.000000  ...   \n",
      "11          1.887678        -20.312303        -288.507800  20.000000  ...   \n",
      "12          1.914321        -20.302480        -288.102445  20.000000  ...   \n",
      "13          2.205674        -20.620175        -289.966778  20.000000  ...   \n",
      "14          2.373377        -20.832665        -291.039161  20.000000  ...   \n",
      "15          2.325815        -20.950335        -291.765325  20.000000  ...   \n",
      "16          2.451823        -21.099370        -292.574406  20.000000  ...   \n",
      "17          2.326419        -21.408250        -294.509706  20.000000  ...   \n",
      "18          2.412810        -21.468145        -295.071057  20.000000  ...   \n",
      "19          2.429837        -21.374413        -294.819200  20.000000  ...   \n",
      "\n",
      "        -20.0  0.02608686780828404  0.04181140446832481  0.9987849026613991  \\\n",
      "0  -20.075283            -0.140397             0.200891            0.969501   \n",
      "1  -20.075283            -0.136989             0.220475            0.965725   \n",
      "2  -20.000000             0.041430             0.034837            0.998534   \n",
      "3  -20.000000             0.052495             0.029825            0.998176   \n",
      "4  -20.000000             0.065145             0.027374            0.997500   \n",
      "5  -20.000000             0.065145             0.027374            0.997500   \n",
      "6  -20.000000             0.065145             0.027374            0.997500   \n",
      "7  -20.000000             0.067222             0.026625            0.997383   \n",
      "8  -20.000000             0.067222             0.026625            0.997383   \n",
      "9  -20.000000             0.066239             0.023518            0.997527   \n",
      "10 -20.000000             0.066338             0.023840            0.997512   \n",
      "11 -20.000000             0.066338             0.023840            0.997512   \n",
      "12 -20.000000             0.066338             0.023840            0.997512   \n",
      "13 -20.000000             0.064824             0.024375            0.997599   \n",
      "14 -20.000000             0.063962             0.024893            0.997642   \n",
      "15 -20.000000             0.063962             0.024893            0.997642   \n",
      "16 -20.000000             0.063320             0.025199            0.997675   \n",
      "17 -20.000000             0.063320             0.025199            0.997675   \n",
      "18 -20.000000             0.062883             0.025100            0.997705   \n",
      "19 -20.000000             0.062883             0.025100            0.997705   \n",
      "\n",
      "    Unnamed: 15  Unnamed: 16  Unnamed: 17  Unnamed: 18  Unnamed: 19  \\\n",
      "0           NaN          NaN          NaN          NaN          NaN   \n",
      "1           NaN          NaN          NaN          NaN          NaN   \n",
      "2    -39.934928    14.997919   -20.075283    -0.145087     0.230744   \n",
      "3    -39.934928    14.997919   -20.075283    -0.145087     0.230744   \n",
      "4    -39.934928    14.997919   -20.075283    -0.145087     0.230744   \n",
      "5    -39.934928    14.997919   -20.075283    -0.153085     0.220988   \n",
      "6    -39.934928    14.997919   -20.075283    -0.152523     0.222659   \n",
      "7    -39.934928    14.997919   -20.075283    -0.152523     0.222659   \n",
      "8    -39.934928    14.997919   -20.075283    -0.152228     0.229814   \n",
      "9    -39.934928    14.997919   -20.075283    -0.152228     0.229814   \n",
      "10   -39.934928    14.997919   -20.075283    -0.152228     0.229814   \n",
      "11   -39.934928    14.997919   -20.075283    -0.151781     0.233679   \n",
      "12   -39.934928    14.997919   -20.075283    -0.152094     0.233980   \n",
      "13   -39.934928    14.997919   -20.075283    -0.152094     0.233980   \n",
      "14   -39.934928    14.997919   -20.075283    -0.152094     0.233980   \n",
      "15   -39.934928    14.997919   -20.075283    -0.151527     0.234143   \n",
      "16   -39.934928    14.997919   -20.075283    -0.151527     0.234143   \n",
      "17   -39.934928    14.997919   -20.075283    -0.150041     0.234536   \n",
      "18   -39.934928    14.997919   -20.075283    -0.150041     0.234536   \n",
      "19   -39.934928    14.997919   -20.075283    -0.150243     0.234115   \n",
      "\n",
      "    Unnamed: 20  \n",
      "0           NaN  \n",
      "1           NaN  \n",
      "2      0.962137  \n",
      "3      0.962137  \n",
      "4      0.962137  \n",
      "5      0.963187  \n",
      "6      0.962891  \n",
      "7      0.962891  \n",
      "8      0.961255  \n",
      "9      0.961255  \n",
      "10     0.961255  \n",
      "11     0.960394  \n",
      "12     0.960271  \n",
      "13     0.960271  \n",
      "14     0.960271  \n",
      "15     0.960321  \n",
      "16     0.960321  \n",
      "17     0.960458  \n",
      "18     0.960458  \n",
      "19     0.960530  \n",
      "\n",
      "[20 rows x 21 columns]\n"
     ]
    }
   ],
   "source": [
    "sheet2 = pd.read_csv(r'C:\\Users\\86152\\Desktop\\gaze.csv',skiprows=3, nrows=20)\n",
    "print(sheet2)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}
